package com.vanguard.p2p.business.example;

import java.util.ArrayList;
import java.util.List;

public class BaseInformationExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public BaseInformationExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andBaseInfoIdIsNull() {
            addCriterion("base_info_id is null");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdIsNotNull() {
            addCriterion("base_info_id is not null");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdEqualTo(Long value) {
            addCriterion("base_info_id =", value, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdNotEqualTo(Long value) {
            addCriterion("base_info_id <>", value, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdGreaterThan(Long value) {
            addCriterion("base_info_id >", value, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdGreaterThanOrEqualTo(Long value) {
            addCriterion("base_info_id >=", value, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdLessThan(Long value) {
            addCriterion("base_info_id <", value, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdLessThanOrEqualTo(Long value) {
            addCriterion("base_info_id <=", value, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdIn(List<Long> values) {
            addCriterion("base_info_id in", values, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdNotIn(List<Long> values) {
            addCriterion("base_info_id not in", values, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdBetween(Long value1, Long value2) {
            addCriterion("base_info_id between", value1, value2, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andBaseInfoIdNotBetween(Long value1, Long value2) {
            addCriterion("base_info_id not between", value1, value2, "baseInfoId");
            return (Criteria) this;
        }

        public Criteria andMemIdIsNull() {
            addCriterion("mem_id is null");
            return (Criteria) this;
        }

        public Criteria andMemIdIsNotNull() {
            addCriterion("mem_id is not null");
            return (Criteria) this;
        }

        public Criteria andMemIdEqualTo(Long value) {
            addCriterion("mem_id =", value, "memId");
            return (Criteria) this;
        }

        public Criteria andMemIdNotEqualTo(Long value) {
            addCriterion("mem_id <>", value, "memId");
            return (Criteria) this;
        }

        public Criteria andMemIdGreaterThan(Long value) {
            addCriterion("mem_id >", value, "memId");
            return (Criteria) this;
        }

        public Criteria andMemIdGreaterThanOrEqualTo(Long value) {
            addCriterion("mem_id >=", value, "memId");
            return (Criteria) this;
        }

        public Criteria andMemIdLessThan(Long value) {
            addCriterion("mem_id <", value, "memId");
            return (Criteria) this;
        }

        public Criteria andMemIdLessThanOrEqualTo(Long value) {
            addCriterion("mem_id <=", value, "memId");
            return (Criteria) this;
        }

        public Criteria andMemIdIn(List<Long> values) {
            addCriterion("mem_id in", values, "memId");
            return (Criteria) this;
        }

        public Criteria andMemIdNotIn(List<Long> values) {
            addCriterion("mem_id not in", values, "memId");
            return (Criteria) this;
        }

        public Criteria andMemIdBetween(Long value1, Long value2) {
            addCriterion("mem_id between", value1, value2, "memId");
            return (Criteria) this;
        }

        public Criteria andMemIdNotBetween(Long value1, Long value2) {
            addCriterion("mem_id not between", value1, value2, "memId");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("version is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("version is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Integer value) {
            addCriterion("version =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Integer value) {
            addCriterion("version <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Integer value) {
            addCriterion("version >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Integer value) {
            addCriterion("version >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Integer value) {
            addCriterion("version <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Integer value) {
            addCriterion("version <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Integer> values) {
            addCriterion("version in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Integer> values) {
            addCriterion("version not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Integer value1, Integer value2) {
            addCriterion("version between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Integer value1, Integer value2) {
            addCriterion("version not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andBitStateIsNull() {
            addCriterion("bit_state is null");
            return (Criteria) this;
        }

        public Criteria andBitStateIsNotNull() {
            addCriterion("bit_state is not null");
            return (Criteria) this;
        }

        public Criteria andBitStateEqualTo(Long value) {
            addCriterion("bit_state =", value, "bitState");
            return (Criteria) this;
        }

        public Criteria andBitStateNotEqualTo(Long value) {
            addCriterion("bit_state <>", value, "bitState");
            return (Criteria) this;
        }

        public Criteria andBitStateGreaterThan(Long value) {
            addCriterion("bit_state >", value, "bitState");
            return (Criteria) this;
        }

        public Criteria andBitStateGreaterThanOrEqualTo(Long value) {
            addCriterion("bit_state >=", value, "bitState");
            return (Criteria) this;
        }

        public Criteria andBitStateLessThan(Long value) {
            addCriterion("bit_state <", value, "bitState");
            return (Criteria) this;
        }

        public Criteria andBitStateLessThanOrEqualTo(Long value) {
            addCriterion("bit_state <=", value, "bitState");
            return (Criteria) this;
        }

        public Criteria andBitStateIn(List<Long> values) {
            addCriterion("bit_state in", values, "bitState");
            return (Criteria) this;
        }

        public Criteria andBitStateNotIn(List<Long> values) {
            addCriterion("bit_state not in", values, "bitState");
            return (Criteria) this;
        }

        public Criteria andBitStateBetween(Long value1, Long value2) {
            addCriterion("bit_state between", value1, value2, "bitState");
            return (Criteria) this;
        }

        public Criteria andBitStateNotBetween(Long value1, Long value2) {
            addCriterion("bit_state not between", value1, value2, "bitState");
            return (Criteria) this;
        }

        public Criteria andRealNameIsNull() {
            addCriterion("real_name is null");
            return (Criteria) this;
        }

        public Criteria andRealNameIsNotNull() {
            addCriterion("real_name is not null");
            return (Criteria) this;
        }

        public Criteria andRealNameEqualTo(String value) {
            addCriterion("real_name =", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotEqualTo(String value) {
            addCriterion("real_name <>", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameGreaterThan(String value) {
            addCriterion("real_name >", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameGreaterThanOrEqualTo(String value) {
            addCriterion("real_name >=", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameLessThan(String value) {
            addCriterion("real_name <", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameLessThanOrEqualTo(String value) {
            addCriterion("real_name <=", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameLike(String value) {
            addCriterion("real_name like", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotLike(String value) {
            addCriterion("real_name not like", value, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameIn(List<String> values) {
            addCriterion("real_name in", values, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotIn(List<String> values) {
            addCriterion("real_name not in", values, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameBetween(String value1, String value2) {
            addCriterion("real_name between", value1, value2, "realName");
            return (Criteria) this;
        }

        public Criteria andRealNameNotBetween(String value1, String value2) {
            addCriterion("real_name not between", value1, value2, "realName");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(Integer value) {
            addCriterion("sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(Integer value) {
            addCriterion("sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(Integer value) {
            addCriterion("sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(Integer value) {
            addCriterion("sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(Integer value) {
            addCriterion("sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<Integer> values) {
            addCriterion("sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<Integer> values) {
            addCriterion("sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(Integer value1, Integer value2) {
            addCriterion("sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(Integer value1, Integer value2) {
            addCriterion("sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andScoreIsNull() {
            addCriterion("score is null");
            return (Criteria) this;
        }

        public Criteria andScoreIsNotNull() {
            addCriterion("score is not null");
            return (Criteria) this;
        }

        public Criteria andScoreEqualTo(Integer value) {
            addCriterion("score =", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotEqualTo(Integer value) {
            addCriterion("score <>", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThan(Integer value) {
            addCriterion("score >", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreGreaterThanOrEqualTo(Integer value) {
            addCriterion("score >=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThan(Integer value) {
            addCriterion("score <", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreLessThanOrEqualTo(Integer value) {
            addCriterion("score <=", value, "score");
            return (Criteria) this;
        }

        public Criteria andScoreIn(List<Integer> values) {
            addCriterion("score in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotIn(List<Integer> values) {
            addCriterion("score not in", values, "score");
            return (Criteria) this;
        }

        public Criteria andScoreBetween(Integer value1, Integer value2) {
            addCriterion("score between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andScoreNotBetween(Integer value1, Integer value2) {
            addCriterion("score not between", value1, value2, "score");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdIsNull() {
            addCriterion("real_auth_id is null");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdIsNotNull() {
            addCriterion("real_auth_id is not null");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdEqualTo(Long value) {
            addCriterion("real_auth_id =", value, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdNotEqualTo(Long value) {
            addCriterion("real_auth_id <>", value, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdGreaterThan(Long value) {
            addCriterion("real_auth_id >", value, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdGreaterThanOrEqualTo(Long value) {
            addCriterion("real_auth_id >=", value, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdLessThan(Long value) {
            addCriterion("real_auth_id <", value, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdLessThanOrEqualTo(Long value) {
            addCriterion("real_auth_id <=", value, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdIn(List<Long> values) {
            addCriterion("real_auth_id in", values, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdNotIn(List<Long> values) {
            addCriterion("real_auth_id not in", values, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdBetween(Long value1, Long value2) {
            addCriterion("real_auth_id between", value1, value2, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andRealAuthIdNotBetween(Long value1, Long value2) {
            addCriterion("real_auth_id not between", value1, value2, "realAuthId");
            return (Criteria) this;
        }

        public Criteria andIdNumberIsNull() {
            addCriterion("id_number is null");
            return (Criteria) this;
        }

        public Criteria andIdNumberIsNotNull() {
            addCriterion("id_number is not null");
            return (Criteria) this;
        }

        public Criteria andIdNumberEqualTo(String value) {
            addCriterion("id_number =", value, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberNotEqualTo(String value) {
            addCriterion("id_number <>", value, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberGreaterThan(String value) {
            addCriterion("id_number >", value, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberGreaterThanOrEqualTo(String value) {
            addCriterion("id_number >=", value, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberLessThan(String value) {
            addCriterion("id_number <", value, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberLessThanOrEqualTo(String value) {
            addCriterion("id_number <=", value, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberLike(String value) {
            addCriterion("id_number like", value, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberNotLike(String value) {
            addCriterion("id_number not like", value, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberIn(List<String> values) {
            addCriterion("id_number in", values, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberNotIn(List<String> values) {
            addCriterion("id_number not in", values, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberBetween(String value1, String value2) {
            addCriterion("id_number between", value1, value2, "idNumber");
            return (Criteria) this;
        }

        public Criteria andIdNumberNotBetween(String value1, String value2) {
            addCriterion("id_number not between", value1, value2, "idNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIsNull() {
            addCriterion("phone_number is null");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIsNotNull() {
            addCriterion("phone_number is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberEqualTo(String value) {
            addCriterion("phone_number =", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotEqualTo(String value) {
            addCriterion("phone_number <>", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberGreaterThan(String value) {
            addCriterion("phone_number >", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberGreaterThanOrEqualTo(String value) {
            addCriterion("phone_number >=", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLessThan(String value) {
            addCriterion("phone_number <", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLessThanOrEqualTo(String value) {
            addCriterion("phone_number <=", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberLike(String value) {
            addCriterion("phone_number like", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotLike(String value) {
            addCriterion("phone_number not like", value, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberIn(List<String> values) {
            addCriterion("phone_number in", values, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotIn(List<String> values) {
            addCriterion("phone_number not in", values, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberBetween(String value1, String value2) {
            addCriterion("phone_number between", value1, value2, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andPhoneNumberNotBetween(String value1, String value2) {
            addCriterion("phone_number not between", value1, value2, "phoneNumber");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdIsNull() {
            addCriterion("income_grade_id is null");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdIsNotNull() {
            addCriterion("income_grade_id is not null");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdEqualTo(Long value) {
            addCriterion("income_grade_id =", value, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdNotEqualTo(Long value) {
            addCriterion("income_grade_id <>", value, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdGreaterThan(Long value) {
            addCriterion("income_grade_id >", value, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdGreaterThanOrEqualTo(Long value) {
            addCriterion("income_grade_id >=", value, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdLessThan(Long value) {
            addCriterion("income_grade_id <", value, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdLessThanOrEqualTo(Long value) {
            addCriterion("income_grade_id <=", value, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdIn(List<Long> values) {
            addCriterion("income_grade_id in", values, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdNotIn(List<Long> values) {
            addCriterion("income_grade_id not in", values, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdBetween(Long value1, Long value2) {
            addCriterion("income_grade_id between", value1, value2, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andIncomeGradeIdNotBetween(Long value1, Long value2) {
            addCriterion("income_grade_id not between", value1, value2, "incomeGradeId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdIsNull() {
            addCriterion("marriage_id is null");
            return (Criteria) this;
        }

        public Criteria andMarriageIdIsNotNull() {
            addCriterion("marriage_id is not null");
            return (Criteria) this;
        }

        public Criteria andMarriageIdEqualTo(Long value) {
            addCriterion("marriage_id =", value, "marriageId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdNotEqualTo(Long value) {
            addCriterion("marriage_id <>", value, "marriageId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdGreaterThan(Long value) {
            addCriterion("marriage_id >", value, "marriageId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdGreaterThanOrEqualTo(Long value) {
            addCriterion("marriage_id >=", value, "marriageId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdLessThan(Long value) {
            addCriterion("marriage_id <", value, "marriageId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdLessThanOrEqualTo(Long value) {
            addCriterion("marriage_id <=", value, "marriageId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdIn(List<Long> values) {
            addCriterion("marriage_id in", values, "marriageId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdNotIn(List<Long> values) {
            addCriterion("marriage_id not in", values, "marriageId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdBetween(Long value1, Long value2) {
            addCriterion("marriage_id between", value1, value2, "marriageId");
            return (Criteria) this;
        }

        public Criteria andMarriageIdNotBetween(Long value1, Long value2) {
            addCriterion("marriage_id not between", value1, value2, "marriageId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdIsNull() {
            addCriterion("kid_count_id is null");
            return (Criteria) this;
        }

        public Criteria andKidCountIdIsNotNull() {
            addCriterion("kid_count_id is not null");
            return (Criteria) this;
        }

        public Criteria andKidCountIdEqualTo(Long value) {
            addCriterion("kid_count_id =", value, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdNotEqualTo(Long value) {
            addCriterion("kid_count_id <>", value, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdGreaterThan(Long value) {
            addCriterion("kid_count_id >", value, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdGreaterThanOrEqualTo(Long value) {
            addCriterion("kid_count_id >=", value, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdLessThan(Long value) {
            addCriterion("kid_count_id <", value, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdLessThanOrEqualTo(Long value) {
            addCriterion("kid_count_id <=", value, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdIn(List<Long> values) {
            addCriterion("kid_count_id in", values, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdNotIn(List<Long> values) {
            addCriterion("kid_count_id not in", values, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdBetween(Long value1, Long value2) {
            addCriterion("kid_count_id between", value1, value2, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andKidCountIdNotBetween(Long value1, Long value2) {
            addCriterion("kid_count_id not between", value1, value2, "kidCountId");
            return (Criteria) this;
        }

        public Criteria andEducationIdIsNull() {
            addCriterion("education_id is null");
            return (Criteria) this;
        }

        public Criteria andEducationIdIsNotNull() {
            addCriterion("education_id is not null");
            return (Criteria) this;
        }

        public Criteria andEducationIdEqualTo(Long value) {
            addCriterion("education_id =", value, "educationId");
            return (Criteria) this;
        }

        public Criteria andEducationIdNotEqualTo(Long value) {
            addCriterion("education_id <>", value, "educationId");
            return (Criteria) this;
        }

        public Criteria andEducationIdGreaterThan(Long value) {
            addCriterion("education_id >", value, "educationId");
            return (Criteria) this;
        }

        public Criteria andEducationIdGreaterThanOrEqualTo(Long value) {
            addCriterion("education_id >=", value, "educationId");
            return (Criteria) this;
        }

        public Criteria andEducationIdLessThan(Long value) {
            addCriterion("education_id <", value, "educationId");
            return (Criteria) this;
        }

        public Criteria andEducationIdLessThanOrEqualTo(Long value) {
            addCriterion("education_id <=", value, "educationId");
            return (Criteria) this;
        }

        public Criteria andEducationIdIn(List<Long> values) {
            addCriterion("education_id in", values, "educationId");
            return (Criteria) this;
        }

        public Criteria andEducationIdNotIn(List<Long> values) {
            addCriterion("education_id not in", values, "educationId");
            return (Criteria) this;
        }

        public Criteria andEducationIdBetween(Long value1, Long value2) {
            addCriterion("education_id between", value1, value2, "educationId");
            return (Criteria) this;
        }

        public Criteria andEducationIdNotBetween(Long value1, Long value2) {
            addCriterion("education_id not between", value1, value2, "educationId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdIsNull() {
            addCriterion("house_condition_id is null");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdIsNotNull() {
            addCriterion("house_condition_id is not null");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdEqualTo(Long value) {
            addCriterion("house_condition_id =", value, "houseConditionId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdNotEqualTo(Long value) {
            addCriterion("house_condition_id <>", value, "houseConditionId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdGreaterThan(Long value) {
            addCriterion("house_condition_id >", value, "houseConditionId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdGreaterThanOrEqualTo(Long value) {
            addCriterion("house_condition_id >=", value, "houseConditionId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdLessThan(Long value) {
            addCriterion("house_condition_id <", value, "houseConditionId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdLessThanOrEqualTo(Long value) {
            addCriterion("house_condition_id <=", value, "houseConditionId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdIn(List<Long> values) {
            addCriterion("house_condition_id in", values, "houseConditionId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdNotIn(List<Long> values) {
            addCriterion("house_condition_id not in", values, "houseConditionId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdBetween(Long value1, Long value2) {
            addCriterion("house_condition_id between", value1, value2, "houseConditionId");
            return (Criteria) this;
        }

        public Criteria andHouseConditionIdNotBetween(Long value1, Long value2) {
            addCriterion("house_condition_id not between", value1, value2, "houseConditionId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}